0

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4389009475708 335 1.0095 0


No Amazon API Requests Made.


App Debug - Total Time 1.4389009475708 seconds

Number Time From Start Name Description
1 0.406986951828 Initialise Initialise FSB Function
2 0.40892291069031 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43323111534119 Start of getCategoryListByGroup Function Before first category groups query
4 0.43416404724121 After initial query Before first category groups query
5 0.43416500091553 Get Category List for Group Before the call to getCategoryList function
6 0.43416714668274 Start of GetCategoryList function Start of the function
7 0.43416905403137 Before getting categories Query to get specific category list
8 0.43507695198059 After getting categories Query to get specific category list
9 0.43507695198059 Before getting category custom Before call to function getCategoryCustom
10 0.45185208320618 After getting category custom After call to function getCategoryCustom
11 0.45185399055481 Before getting category custom Before call to function getCategoryCustom
12 0.46055793762207 After getting category custom After call to function getCategoryCustom
13 0.46055912971497 Before getting category custom Before call to function getCategoryCustom
14 0.4650559425354 After getting category custom After call to function getCategoryCustom
15 0.46505808830261 Before getting category custom Before call to function getCategoryCustom
16 0.46867609024048 After getting category custom After call to function getCategoryCustom
17 0.46867704391479 Before getting category custom Before call to function getCategoryCustom
18 0.47170114517212 After getting category custom After call to function getCategoryCustom
19 0.47170209884644 Before getting category custom Before call to function getCategoryCustom
20 0.47463393211365 After getting category custom After call to function getCategoryCustom
21 0.47463512420654 End of GetCategoryList function End of the function
22 0.4746401309967 Get Category List for Group Before the call to getCategoryList function
23 0.47464203834534 Start of GetCategoryList function Start of the function
24 0.47464203834534 Before getting categories Query to get specific category list
25 0.47498798370361 End of getCategoryListByGroup Function Before return()
26 1.2602651119232 App Controller End End of the App controller (called before the controller of every page)
27 1.369735956192 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3707721233368 Before Get Options Before the call to getOptions in the tpl class
29 1.4113829135895 After Get Options After the call to getOptions in the tpl class
30 1.4114100933075 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4388921260834 Finalizing debug Before the debug is output to the page.
32 1.4388999938965 End of App This is the end of the app logging, final timestamp


Query Debug - 335 Database Queries. Total time 1.0095 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.0017189979553223
SELECT parameter, value FROM parameters
2 0.0049 0.0048658847808838
SELECT * FROM `bad_bots`
3 0.0003 0.00031399726867676
SET time_zone = 'Europe/London'
4 0.0015 0.0014519691467285
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0014 0.001417875289917
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"216.73.217.7\";}'
6 0.0012 0.0011568069458008
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751341731'
7 0.0014 0.0014121532440186
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00030398368835449
UPDATE autorun SET lastrun = '2025-07-01 03:48:51' WHERE id = '16'
9 0.0004 0.00035500526428223
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0008 0.00082993507385254
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0002 0.00023794174194336
SELECT * FROM pages WHERE id = 52
12 0.0015 0.001521110534668
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0220 0.021994113922119
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0005 0.00047707557678223
SELECT * FROM pages WHERE pagename = 'search'
15 0.0009 0.00092792510986328
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0009 0.00089693069458008
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0060 0.0059559345245361
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0010 0.0010049343109131
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0007 0.00070309638977051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '26'
21 0.0050 0.0049858093261719
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0009 0.00092720985412598
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0018 0.0018019676208496
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0007 0.00074887275695801
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.0002892017364502
SELECT * FROM categorygroups WHERE id = '1'
26 0.0031 0.0031239986419678
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0003 0.0003349781036377
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00026679039001465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00030994415283203
SELECT id FROM categories WHERE parent_id = '27'
30 0.0033 0.0032720565795898
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0004 0.0003809928894043
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0003 0.00034093856811523
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00027894973754883
SELECT * FROM categorygroups WHERE id = '1'
35 0.0012 0.0012359619140625
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0003 0.00030112266540527
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '28'
39 0.0012 0.001162052154541
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0003 0.00031590461730957
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0003 0.00033187866210938
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0003 0.00029397010803223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.0002739429473877
SELECT * FROM categorygroups WHERE id = '1'
44 0.0008 0.000762939453125
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0004 0.00041484832763672
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.00030684471130371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00034999847412109
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00050115585327148
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0003 0.00032901763916016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.00030398368835449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00028705596923828
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.00038313865661621
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00032186508178711
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00029611587524414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00030088424682617
SELECT id FROM categories WHERE parent_id = '30'
57 0.0004 0.00044989585876465
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0003 0.00032591819763184
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0003 0.0002899169921875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00027203559875488
SELECT * FROM categorygroups WHERE id = '1'
62 0.0004 0.00040602684020996
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.00029182434082031
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00028800964355469
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00046014785766602
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0003 0.00030708312988281
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0003 0.00031495094299316
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0003 0.00028896331787109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.0002901554107666
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00034213066101074
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0020 0.0020449161529541
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0009 0.00087904930114746
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.00036811828613281
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0007 0.00074195861816406
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0010 0.00095105171203613
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00064802169799805
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7756 0.77561616897583
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.217.7') >= INET_ATON(ip_start) AND INET_ATON('216.73.217.7') <= INET_ATON(ip_end)
79 0.0016 0.0016288757324219
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0007 0.00074410438537598
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.0003969669342041
SELECT * FROM pages WHERE pagename = 'search'
82 0.0050 0.0050430297851562
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0014 0.0013968944549561
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0010 0.0009758472442627
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0048 0.0048298835754395
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0014 0.001352071762085
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00035500526428223
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0008 0.00078487396240234
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'palais des thes the vert thE du hammam bote metal 100g', NOW(), '216.73.217.7'
89 0.0005 0.00051689147949219
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0003 0.00034904479980469
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0043 0.0043120384216309
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'palais') OR (keyfeatures LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (keyfeatures LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (keyfeatures LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'thE') OR (keyfeatures LIKE 'thE') OR (title LIKE 'thE') OR (description LIKE 'du') OR (keyfeatures LIKE 'du') OR (title LIKE 'du') OR (description LIKE 'hammam') OR (keyfeatures LIKE 'hammam') OR (title LIKE 'hammam') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (keyfeatures LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '100g') OR (keyfeatures LIKE '100g') OR (title LIKE '100g'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0004 0.00035595893859863
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'thE') OR (title LIKE 'thE') OR (description LIKE 'du') OR (title LIKE 'du') OR (description LIKE 'hammam') OR (title LIKE 'hammam') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '100g') OR (title LIKE '100g'))
		AND hide = 0
93 0.0004 0.00037503242492676
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'thE') OR (title LIKE 'thE') OR (description LIKE 'du') OR (title LIKE 'du') OR (description LIKE 'hammam') OR (title LIKE 'hammam') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '100g') OR (title LIKE '100g'))
		AND hide = 0
94 0.0003 0.00034403800964355
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
95 0.0058 0.005836009979248
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%palais%') OR (keyfeatures LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (keyfeatures LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (keyfeatures LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%thE%') OR (keyfeatures LIKE '%thE%') OR (title LIKE '%thE%') OR (description LIKE '%du%') OR (keyfeatures LIKE '%du%') OR (title LIKE '%du%') OR (description LIKE '%hammam%') OR (keyfeatures LIKE '%hammam%') OR (title LIKE '%hammam%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (keyfeatures LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%100g%') OR (keyfeatures LIKE '%100g%') OR (title LIKE '%100g%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
96 0.0003 0.00027298927307129
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%thE%') OR (title LIKE '%thE%') OR (description LIKE '%du%') OR (title LIKE '%du%') OR (description LIKE '%hammam%') OR (title LIKE '%hammam%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%100g%') OR (title LIKE '%100g%'))
		AND hide = 0
97 0.0002 0.00024104118347168
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%thE%') OR (title LIKE '%thE%') OR (description LIKE '%du%') OR (title LIKE '%du%') OR (description LIKE '%hammam%') OR (title LIKE '%hammam%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%100g%') OR (title LIKE '%100g%'))
		AND hide = 0
98 0.0003 0.00034117698669434
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0004 0.00037980079650879
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0043 0.0043280124664307
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'palais') OR (keyfeatures LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (keyfeatures LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (keyfeatures LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'thE') OR (keyfeatures LIKE 'thE') OR (title LIKE 'thE') OR (description LIKE 'du') OR (keyfeatures LIKE 'du') OR (title LIKE 'du') OR (description LIKE 'hammam') OR (keyfeatures LIKE 'hammam') OR (title LIKE 'hammam') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (keyfeatures LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '100g') OR (keyfeatures LIKE '100g') OR (title LIKE '100g'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0003 0.0003209114074707
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'thE') OR (title LIKE 'thE') OR (description LIKE 'du') OR (title LIKE 'du') OR (description LIKE 'hammam') OR (title LIKE 'hammam') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '100g') OR (title LIKE '100g'))
		AND hide = 0
102 0.0003 0.0002739429473877
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'thE') OR (title LIKE 'thE') OR (description LIKE 'du') OR (title LIKE 'du') OR (description LIKE 'hammam') OR (title LIKE 'hammam') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '100g') OR (title LIKE '100g'))
		AND hide = 0
103 0.0004 0.00035595893859863
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +thE +du +hammam +bote +metal +100g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0058 0.0057830810546875
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%palais%') OR (keyfeatures LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (keyfeatures LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (keyfeatures LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%thE%') OR (keyfeatures LIKE '%thE%') OR (title LIKE '%thE%') OR (description LIKE '%du%') OR (keyfeatures LIKE '%du%') OR (title LIKE '%du%') OR (description LIKE '%hammam%') OR (keyfeatures LIKE '%hammam%') OR (title LIKE '%hammam%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (keyfeatures LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%100g%') OR (keyfeatures LIKE '%100g%') OR (title LIKE '%100g%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0003 0.00029301643371582
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%thE%') OR (title LIKE '%thE%') OR (description LIKE '%du%') OR (title LIKE '%du%') OR (description LIKE '%hammam%') OR (title LIKE '%hammam%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%100g%') OR (title LIKE '%100g%'))
		AND hide = 0
106 0.0003 0.00026106834411621
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%thE%') OR (title LIKE '%thE%') OR (description LIKE '%du%') OR (title LIKE '%du%') OR (description LIKE '%hammam%') OR (title LIKE '%hammam%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%100g%') OR (title LIKE '%100g%'))
		AND hide = 0
107 0.0003 0.00030183792114258
SELECT * FROM products WHERE id = '4950'
108 0.0010 0.0010099411010742
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
109 0.0008 0.00081610679626465
SELECT * FROM product_image_select WHERE product_id = '4950'
110 0.0007 0.00070381164550781
SELECT * FROM productcustomimages WHERE product_id = '4950'
111 0.0011 0.0011358261108398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
112 0.0008 0.00077295303344727
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0003 0.00030279159545898
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0004 0.0003662109375
SELECT * FROM products WHERE id = '4953'
116 0.0004 0.00042319297790527
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
117 0.0006 0.00057506561279297
SELECT * FROM product_image_select WHERE product_id = '4953'
118 0.0003 0.00032901763916016
SELECT * FROM productcustomimages WHERE product_id = '4953'
119 0.0007 0.00067901611328125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
120 0.0003 0.00032615661621094
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0004 0.0003509521484375
SELECT * FROM products WHERE id = '4933'
124 0.0003 0.00034117698669434
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
125 0.0005 0.00048303604125977
SELECT * FROM product_image_select WHERE product_id = '4933'
126 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '4933'
127 0.0008 0.00075507164001465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
128 0.0003 0.00034904479980469
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0003 0.00027990341186523
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0004 0.00036311149597168
SELECT * FROM products WHERE id = '4926'
132 0.0004 0.00037002563476562
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
133 0.0005 0.00048184394836426
SELECT * FROM product_image_select WHERE product_id = '4926'
134 0.0003 0.0003209114074707
SELECT * FROM productcustomimages WHERE product_id = '4926'
135 0.0009 0.00089812278747559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
136 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00029683113098145
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0004 0.00037693977355957
SELECT * FROM products WHERE id = '868'
140 0.0004 0.00038480758666992
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
141 0.0005 0.00046896934509277
SELECT * FROM product_image_select WHERE product_id = '868'
142 0.0003 0.00033903121948242
SELECT * FROM productcustomimages WHERE product_id = '868'
143 0.0007 0.00065994262695312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
144 0.0003 0.00031518936157227
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0003 0.00026917457580566
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0003 0.00034809112548828
SELECT * FROM products WHERE id = '4919'
148 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
149 0.0005 0.00047898292541504
SELECT * FROM product_image_select WHERE product_id = '4919'
150 0.0003 0.00028800964355469
SELECT * FROM productcustomimages WHERE product_id = '4919'
151 0.0008 0.00080704689025879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
152 0.0003 0.00033712387084961
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0003 0.00029611587524414
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0005 0.00046014785766602
SELECT * FROM products WHERE id = '862'
156 0.0004 0.00038790702819824
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
157 0.0005 0.00048208236694336
SELECT * FROM product_image_select WHERE product_id = '862'
158 0.0003 0.00029492378234863
SELECT * FROM productcustomimages WHERE product_id = '862'
159 0.0007 0.00067687034606934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
160 0.0003 0.00032377243041992
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0004 0.00036001205444336
SELECT * FROM products WHERE id = '4122'
164 0.0004 0.00038599967956543
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
165 0.0005 0.00047516822814941
SELECT * FROM product_image_select WHERE product_id = '4122'
166 0.0003 0.00027918815612793
SELECT * FROM productcustomimages WHERE product_id = '4122'
167 0.0007 0.00071382522583008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
168 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0003 0.00028896331787109
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00027918815612793
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0004 0.00037908554077148
SELECT * FROM products WHERE id = '1140'
172 0.0004 0.00039005279541016
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
173 0.0005 0.00048398971557617
SELECT * FROM product_image_select WHERE product_id = '1140'
174 0.0003 0.00032901763916016
SELECT * FROM productcustomimages WHERE product_id = '1140'
175 0.0006 0.00063896179199219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
176 0.0003 0.00034189224243164
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0003 0.00028204917907715
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0003 0.00034999847412109
SELECT * FROM products WHERE id = '1061'
180 0.0004 0.00041508674621582
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
181 0.0005 0.00049090385437012
SELECT * FROM product_image_select WHERE product_id = '1061'
182 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '1061'
183 0.0007 0.00072813034057617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
184 0.0003 0.00032901763916016
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0003 0.00032687187194824
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '2165'
188 0.0004 0.00040102005004883
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
189 0.0005 0.00048208236694336
SELECT * FROM product_image_select WHERE product_id = '2165'
190 0.0003 0.00029110908508301
SELECT * FROM productcustomimages WHERE product_id = '2165'
191 0.0006 0.0006258487701416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
192 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0003 0.00028204917907715
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00026607513427734
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0003 0.00033998489379883
SELECT * FROM products WHERE id = '1110'
196 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
197 0.0005 0.0004880428314209
SELECT * FROM product_image_select WHERE product_id = '1110'
198 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '1110'
199 0.0007 0.00074887275695801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
200 0.0004 0.00036287307739258
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00027680397033691
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00029110908508301
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0004 0.00038695335388184
SELECT * FROM products WHERE id = '4930'
204 0.0004 0.0003960132598877
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
205 0.0005 0.0004570484161377
SELECT * FROM product_image_select WHERE product_id = '4930'
206 0.0003 0.00031900405883789
SELECT * FROM productcustomimages WHERE product_id = '4930'
207 0.0007 0.0007481575012207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
208 0.0003 0.00034403800964355
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0003 0.00028800964355469
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0004 0.00037312507629395
SELECT * FROM products WHERE id = '1160'
212 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
213 0.0005 0.00045108795166016
SELECT * FROM product_image_select WHERE product_id = '1160'
214 0.0003 0.00026512145996094
SELECT * FROM productcustomimages WHERE product_id = '1160'
215 0.0007 0.00072312355041504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
216 0.0003 0.0003352165222168
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = '4940'
220 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
221 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '4940'
222 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '4940'
223 0.0006 0.00058507919311523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
224 0.0003 0.00032687187194824
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00031304359436035
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.00041794776916504
SELECT * FROM products WHERE id = '1055'
228 0.0005 0.00047707557678223
SELECT * FROM productimages WHERE product_id = '1055' ORDER BY sortorder ASC
229 0.0006 0.00056886672973633
SELECT * FROM product_image_select WHERE product_id = '1055'
230 0.0003 0.00031399726867676
SELECT * FROM productcustomimages WHERE product_id = '1055'
231 0.0006 0.00063920021057129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1055' AND a.name = n.originalname
232 0.0003 0.00032591819763184
SELECT * FROM productoffers WHERE product_id = '1055' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0003 0.00027585029602051
SELECT * FROM productoffers
                WHERE product_id = '1055' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '1055' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0004 0.00036001205444336
SELECT * FROM products WHERE id = '1215'
236 0.0005 0.00046586990356445
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
237 0.0005 0.00046920776367188
SELECT * FROM product_image_select WHERE product_id = '1215'
238 0.0003 0.00028419494628906
SELECT * FROM productcustomimages WHERE product_id = '1215'
239 0.0007 0.00074505805969238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1215' AND a.name = n.originalname
240 0.0003 0.00032901763916016
SELECT * FROM productoffers WHERE product_id = '1215' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '1215' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0003 0.00029683113098145
SELECT value FROM productattributes WHERE product_id = '1215' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0003 0.00034689903259277
SELECT * FROM products WHERE id = '770'
244 0.0004 0.00039887428283691
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
245 0.0005 0.00049400329589844
SELECT * FROM product_image_select WHERE product_id = '770'
246 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '770'
247 0.0007 0.00072693824768066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
248 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0003 0.00026893615722656
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0003 0.00028204917907715
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0011 0.0010919570922852
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
252 0.0002 0.00023984909057617
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
253 0.0002 0.00022411346435547
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
254 0.0002 0.00022506713867188
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
255 0.0002 0.00022411346435547
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
256 0.0002 0.00022983551025391
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
257 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
258 0.0002 0.00022196769714355
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
259 0.0002 0.00021910667419434
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
260 0.0002 0.0002281665802002
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
261 0.0002 0.00022101402282715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
262 0.0002 0.00023794174194336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
263 0.0002 0.00024104118347168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
264 0.0002 0.00021791458129883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
265 0.0002 0.00024199485778809
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
266 0.0002 0.00020909309387207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1055' ORDER BY timestamp DESC
267 0.0002 0.00022411346435547
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1215' ORDER BY timestamp DESC
268 0.0002 0.0002131462097168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
269 0.0009 0.0008540153503418
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
270 0.0007 0.00073385238647461
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
271 0.0003 0.00026702880859375
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
272 0.0120 0.011989831924438
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
273 0.0010 0.00097990036010742
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
274 0.0004 0.00039911270141602
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
275 0.0004 0.00040388107299805
SELECT * FROM products WHERE id = 1626
276 0.0003 0.00027680397033691
SELECT * FROM products WHERE id = 4041
277 0.0003 0.00032687187194824
SELECT * FROM products WHERE id = 4312
278 0.0003 0.00030303001403809
SELECT * FROM products WHERE id = 777
279 0.0003 0.00027608871459961
SELECT * FROM products WHERE id = 3881
280 0.0003 0.00026106834411621
SELECT * FROM products WHERE id = 4213
281 0.0003 0.00027298927307129
SELECT * FROM products WHERE id = '1626'
282 0.0003 0.00033283233642578
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
283 0.0005 0.00046801567077637
SELECT * FROM product_image_select WHERE product_id = '1626'
284 0.0003 0.00030088424682617
SELECT * FROM productcustomimages WHERE product_id = '1626'
285 0.0006 0.00062894821166992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
286 0.0004 0.00035405158996582
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0003 0.00029492378234863
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0004 0.00039219856262207
SELECT * FROM products WHERE id = '4041'
290 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
291 0.0005 0.00047111511230469
SELECT * FROM product_image_select WHERE product_id = '4041'
292 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '4041'
293 0.0007 0.00071597099304199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
294 0.0003 0.00031590461730957
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0003 0.0002899169921875
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0004 0.00035190582275391
SELECT * FROM products WHERE id = '4312'
298 0.0003 0.00033378601074219
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
299 0.0005 0.00048208236694336
SELECT * FROM product_image_select WHERE product_id = '4312'
300 0.0003 0.00029182434082031
SELECT * FROM productcustomimages WHERE product_id = '4312'
301 0.0007 0.00073885917663574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
302 0.0004 0.00036787986755371
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
303 0.0003 0.00030112266540527
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0003 0.00029492378234863
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305 0.0004 0.00037097930908203
SELECT * FROM products WHERE id = '777'
306 0.0004 0.00036096572875977
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
307 0.0005 0.00047397613525391
SELECT * FROM product_image_select WHERE product_id = '777'
308 0.0003 0.00031018257141113
SELECT * FROM productcustomimages WHERE product_id = '777'
309 0.0007 0.0007021427154541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
310 0.0003 0.00033092498779297
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
311 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0003 0.00030398368835449
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0004 0.00041508674621582
SELECT * FROM products WHERE id = '3881'
314 0.0004 0.0003969669342041
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
315 0.0005 0.00046706199645996
SELECT * FROM product_image_select WHERE product_id = '3881'
316 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '3881'
317 0.0007 0.00073695182800293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
318 0.0003 0.00034785270690918
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321 0.0004 0.00037407875061035
SELECT * FROM products WHERE id = '4213'
322 0.0004 0.00037479400634766
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
323 0.0005 0.00053095817565918
SELECT * FROM product_image_select WHERE product_id = '4213'
324 0.0003 0.00031113624572754
SELECT * FROM productcustomimages WHERE product_id = '4213'
325 0.0007 0.0007469654083252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
326 0.0003 0.00032997131347656
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
327 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0013 0.0013480186462402
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
330 0.0005 0.00052380561828613
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
331 0.0016 0.0015888214111328
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
332 0.0010 0.00096487998962402
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
333 0.0004 0.00039887428283691
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
334 0.0006 0.00061511993408203
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
335 0.0004 0.00044393539428711
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'